<?php 
include_once('connection/connection.php');
include('header.php');
include('menu.php');
include('config.php');
$frm=$_SESSION['form_id'];
$id1=$_SESSION['id1'];
$dis_name=$_SESSION['dis_name'];
if(isset($_POST['back']))
{ 
	header('Location: view_q3_1.php');
}	
if(isset($_POST['submit']))
{ 
	header('Location: view_q3_3.php');
}	
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style_question.css" type="text/css" rel="stylesheet" />
<title>View Q3</title>
</head>
<body>
<div align="center">
<form action="" method="post" enctype="multipart/form-data" name="questionnaire3_2" id="questionnaire3_2">
	<table border="0" width="800" id="table1" cellspacing="0" cellpadding="0">
		<tr>
			<td height="30">
			<p align="center">
			<font face="Verdana" style="font-size: 10pt; font-weight: 700" color="#000000">
			Questionnaire No. 3</font></p></td>
		</tr>
		<tr>
			<td height="19">
			<p align="center">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">For 
			Field Survey (Village Level questionnaire) </font></p></td>
		</tr>
		<tr>
			<td height="18">
			<p align="center">
			<font style="font-size: 8.5pt" face="Arial" color="#000000">Page 2</font></p></td>
		</tr>
		<tr>
			<td><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">&nbsp;Form Id = <?php echo $frm?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;District Name = <?php echo $dis_name?></font></span></td>
		</tr>
		<tr><td>&nbsp;</td></tr>
		<tr>
			<td bgcolor="#EEEEEE" height="22"><font color="#000000">&nbsp;
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">3. STATUS OF WATER 
			AVAILABILITY (Average Household Level Survey)</font></span></font></td>
		</tr>
		<tr>
			<td>
			<table border="1" width="1050" id="table4" cellspacing="0" cellpadding="0" bgcolor="#FDF9EE" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td colspan="16"><span style="font-size: 4pt">&nbsp;</span></td>
				</tr>
				<tr>
					<td width="145" align="center" rowspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style:normal" face="Verdana" color="#990000">
				  Habitation</font></address>					</td>
					<td align="center" width="45" rowspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
				  Type MH/ OH</font></address>					</td>
					<td align="center" width="78" rowspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Average Water received per household (lpd)</font>
			      </address>					</td>
					<td align="center" width="87" rowspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<font face="Verdana" style="font-size: 8.5pt; font-style: normal" color="#990000">
				  Average Monthly Spent on water per household (Rs/month)</font></address>					</td>
					<td align="center" width="65" valign="top" height="31" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">House connection</font>
				  </address>					</td>
					<td align="center" height="31" colspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Hand Pump</font>
					</address>					</td>
					<td align="center" height="31" colspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
						<font face="Verdana" color="#990000">Common Tap</font></span>
					</address>
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
				  <font face="Verdana" color="#990000">P&amp;T, PSP</font></span></address>					</td>
					<td align="center" height="31" colspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
				  <font face="Verdana" color="#990000">Traditional Sources</font></span>
					</address>					</td>
					<td align="center" height="31" colspan="2" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Tankers</font></td>
					<td align="center" width="56" valign="top" rowspan="2" bgcolor="#F7E6B7">
					<address>&nbsp;</address>
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
						<font face="Verdana" color="#990000">Water Not Available 
				  (Months)</font></span>
					</address>					</td>
					<td align="center" height="31" colspan="2" valign="top" bgcolor="#F7E6B7">
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
						<font face="Verdana" color="#990000">No. of Hrs./ day 
						available </font></span>
				    </address>					</td>
				</tr>
				<tr>
					<td align="center" width="65" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Qty (lpd)</font>
				  </address>					</td>
					<td align="center" width="67" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Qty (lpd)</font>
				  </address>				  </td>
					<td align="center" width="63" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Average Distance Traveled (m) </font>
				  </address>					</td>
					<td align="center" width="56" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Qty (lpd)</font>
				  </address>					</td>
					<td align="center" width="61" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
					Average Distance Traveled (m)</font></td>
					<td align="center" width="53" valign="top" bgcolor="#F7E6B7">
					<address>
						<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
						Qty (lpd)</font>
				  </address>					</td>
					<td align="center" width="53" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
					Average Distance Traveled (m)</font></td>
					<td align="center" width="51" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
					Qty (lpd)</font></td>
					<td align="center" width="53" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">
					Average Distance Traveled (m)</font></td>
					<td align="center" width="50" valign="top" bgcolor="#F7E6B7">
					<address>
						<span style="font-style: normal; font-size: 8.5pt">
						<font face="Verdana" color="#990000">Pre Monsoon</font></span>
					</address>					</td>
					<td align="center" width="50" valign="top" bgcolor="#F7E6B7">
					<font style="font-size: 8.5pt; font-style: normal" face="Verdana" color="#990000">Post Monsoon</font></td>
				</tr>
				<?php
				$qr2="select * from tbl_dtls_q3_water_status where loc_id='$id1' order by habitation_code asc";
				$res2=mysql_query($qr2);
				while($row=mysql_fetch_array($res2))
				{
				?>
					<tr>
					<td width="145" align="center"><label id="habitation_name"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[habitation_name]";?></font></label>                    </td>
					<td align="center" width="45"><label id="type_habit"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[type_habit]";?></font></label></td>
					<td width="78" align="center">
						<label id="avg_water_recieve"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[avg_water_recieve]";?></font></label></td>
					<td width="87" align="center"><label id="avg_water_spent"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[avg_water_spent]";?></font></label>                    </td>
					<td width="65" align="center"><label id="house_connection"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[house_connection]";?></font></label>                     </td>
					<td width="67" align="center">
					  <label id="hand_pump_qty"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[hand_pump_qty]";?></font></label></td>
					<td width="63" align="center">
					  <label id="hand_pump_distance"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[hand_pump_distance]";?></font></label></td>
					<td width="56" align="center">
					  <label id="common_tap_qty"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[common_tap_qty]";?></font></label></td>
					<td width="61" align="center">
					  <label id="common_tap_distance"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[common_tap_distance]";?></font></label></td>
					<td width="53" align="center">
					  <label id="traditional_src_qty"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[traditional_src_qty]";?></font></label></td>
					<td width="53" align="center">
					  <label id="traditional_src_distance"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[traditional_src_distance]";?></font></label></td>
					<td width="51" align="center">
					  <label id="tanker_qty"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[tanker_qty]";?></font></label></td>
					<td width="53" align="center">
					  <label id="tanker_distance"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[tanker_distance]";?></font></label></td>
					<td width="56" align="center">
					  <label id="water_not_available"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[water_not_available]";?></font></label></td>
					<td width="50" align="center">
						<label id="pre_monsoon"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[pre_monsoon]";?></font></label></td>
					<td width="50" align="center">
						<label id="post_monsoon"><font style="font-size: 8.5pt; font-style: normal" face="Verdana"><?php echo $id="$row[post_monsoon]";?></font></label></td>
				</tr>
				<?php } ?>
				</table>
			</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td bgcolor="#EEEEEE" height="22">&nbsp;</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td>
			<p align="center">
			<input type="submit" value="Back" name="back" style="font-size: 8pt;font-family:Verdana; border-style: solid; border-width: 1px">&nbsp;&nbsp;
			<input type="submit" value="Next" name="submit" style="font-size: 8pt; font-family: Verdana; border-style: solid; border-width: 1px"></p></td>
		</tr>
	</table>
	</form>
</div>
</body>
</html>
